{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Menu","Cad","PE","AC","RC","GR","RI","Instruções","GR_Dados"],"not_rendered":{"charts":6,"images":22,"macros":1,"external_links":0,"defined_names":3,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,4,25,5],[25,6,25,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Empresa:",null,"Sebrae"]

{"sheet":"Cad","index":1,"n_rows":511,"n_cols":24,"rows_kept":511,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Produto","Preço de Venda","Projeções de vendas mensais","Receita bruta mensal","% de Participação","Matéria - Prima","Comissões (%)","Impostos (%)","Outros gastos","Total custo por produto",null,"Custo Fixo","Valor (R$)",null,null,"Comissões (%)","Impostos (%)","Margem de contribuição unitária","IMC (%)","Receita no ponto de equilíbrio","Quantidade a ser vendida","Outros Gastos","Matéria Prima"]
[null,"Camisa",100,50,{"$f":"IFERROR(IF(B12=\"\",\"\",C12*D12),\"\")","v":5000},{"$f":"IFERROR(E12/SUM($E$12:$E$511),\"\")","v":0.19762845849802371},15,0.03,0.12,10,{"$f":"G12+C12*(H12+I12)+J12","v":40},null,"Pró Labore e salários",6500,null,null,{"$f":"IFERROR(H12*E12,\"\")","v":150},{"$f":"IFERROR(I12*E12,\"\")","v":600},{"$f":"IFERROR(C12-K12,\"\")","v":60},{"$f":"IFERROR(S12/C12,\"\")","v":0.6},{"$f":"IFERROR(V12*C12,\"\")","v":7870.7681732256406},{"$f":"IFERROR(F12*PE!$F$20,\"\")","v":78.707681732256404},{"$f":"IFERROR(J12*D12,\"\")","v":500},{"$f":"IFERROR(G12*D12,\"\")","v":750}]
[null,"Calça",120,40,{"$f":"IFERROR(IF(B13=\"\",\"\",C13*D13),\"\")","v":4800},{"$f":"IFERROR(E13/SUM($E$12:$E$511),\"\")","v":0.18972332015810275},28,0.03,0.12,18,{"$f":"G13+C13*(H13+I13)+J13","v":64},null,"Taxa de propriedade (águal e luz)",600,null,null,{"$f":"IFERROR(H13*E13,\"\")","v":144},{"$f":"IFERROR(I13*E13,\"\")","v":576},{"$f":"IFERROR(C13-K13,\"\")","v":56},{"$f":"IFERROR(S13/C13,\"\")","v":0.46666666666666667},{"$f":"IFERROR(V13*C13,\"\")","v":9067.1249355559376},{"$f":"IFERROR(F13*PE!$F$20,\"\")","v":75.559374462966147},{"$f":"IFERROR(J13*D13,\"\")","v":720},{"$f":"IFERROR(G13*D13,\"\")","v":1120}]
[null,"Camiseta",70,200,14000,0.55335968379446643,8,0.03,0.12,6,24.5,null,"Telefone e internet",700,null,null,420,1680,45.5,0.65,15426.705619522258,{"$f":"IFERROR(F14*PE!$F$20,\"\")","v":220.38150885031797},1200,1600]
[null,"Pijamas",50,30,1500,5.9288537549407112E-2,20,0.03,0.12,5,32.5,null,"Aluguel",2000,null,null,45,180,17.5,0.35,1180.6152259838461,{"$f":"IFERROR(F15*PE!$F$20,\"\")","v":23.612304519676922},150,600]
[null,null,null,null,"","",null,null,null,null,0,null,"Marketing",2000,null,null,"","",0,"","",{"$f":"IFERROR(F16*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,"Empréstimos",1350,null,null,"","",0,"","",{"$f":"IFERROR(F17*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,"Legais e Jurídicos",980,null,null,"","",0,"","",{"$f":"IFERROR(F18*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,"Outros Custos",1900,null,null,"","",0,"","",{"$f":"IFERROR(F19*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F20*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,{"$f":"G21+C21*(H21+I21)+J21","v":0},null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F21*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F22*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F23*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F24*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F25*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F26*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F27*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F28*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F29*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,{"$f":"IFERROR(IF(B30=\"\",\"\",C30*D30),\"\")","v":""},"",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F30*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,{"$f":"IFERROR(IF(B31=\"\",\"\",C31*D31),\"\")","v":""},"",null,null,null,null,{"$f":"G31+C31*(H31+I31)+J31","v":0},null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F31*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F32*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F33*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F34*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F35*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F36*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F37*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F38*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F39*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F40*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F41*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F42*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F43*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F44*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F45*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F46*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F47*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F48*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F49*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F50*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F51*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F52*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F53*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F54*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F55*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F56*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F57*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F58*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F59*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F60*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F61*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F62*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F63*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F64*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F65*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F66*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F67*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F68*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F69*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F70*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F71*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F72*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F73*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F74*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F75*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F76*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"",{"$f":"IFERROR(E77/SUM($E$12:$E$511),\"\")","v":""},null,null,null,null,0,null,null,null,null,null,{"$f":"IFERROR(H77*E77,\"\")","v":""},{"$f":"IFERROR(I77*E77,\"\")","v":""},{"$f":"IFERROR(C77-K77,\"\")","v":0},{"$f":"IFERROR(S77/C77,\"\")","v":""},{"$f":"IFERROR(V77*C77,\"\")","v":""},{"$f":"IFERROR(F77*PE!$F$20,\"\")","v":""},{"$f":"IFERROR(J77*D77,\"\")","v":0},{"$f":"IFERROR(G77*D77,\"\")","v":0}]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F78*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F79*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F80*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F81*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F82*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F83*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F84*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F85*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F86*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F87*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F88*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F89*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F90*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F91*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F92*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F93*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F94*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,{"$f":"IFERROR(IF(B95=\"\",\"\",C95*D95),\"\")","v":""},"",null,null,null,null,{"$f":"G95+C95*(H95+I95)+J95","v":0},null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F95*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F96*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F97*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F98*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F99*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F100*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F101*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F102*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F103*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F104*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F105*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F106*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F107*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F108*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F109*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F110*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F111*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F112*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F113*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F114*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F115*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F116*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F117*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F118*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F119*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F120*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F121*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F122*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F123*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F124*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F125*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F126*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F127*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F128*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F129*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F130*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F131*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F132*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F133*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F134*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F135*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F136*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F137*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F138*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F139*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F140*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"",{"$f":"IFERROR(E141/SUM($E$12:$E$511),\"\")","v":""},null,null,null,null,0,null,null,null,null,null,{"$f":"IFERROR(H141*E141,\"\")","v":""},{"$f":"IFERROR(I141*E141,\"\")","v":""},{"$f":"IFERROR(C141-K141,\"\")","v":0},{"$f":"IFERROR(S141/C141,\"\")","v":""},{"$f":"IFERROR(V141*C141,\"\")","v":""},{"$f":"IFERROR(F141*PE!$F$20,\"\")","v":""},{"$f":"IFERROR(J141*D141,\"\")","v":0},{"$f":"IFERROR(G141*D141,\"\")","v":0}]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F142*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F143*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F144*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F145*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F146*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F147*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F148*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F149*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F150*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F151*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F152*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F153*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F154*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F155*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F156*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F157*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F158*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,{"$f":"IFERROR(IF(B159=\"\",\"\",C159*D159),\"\")","v":""},"",null,null,null,null,{"$f":"G159+C159*(H159+I159)+J159","v":0},null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F159*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F160*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F161*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F162*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F163*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F164*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F165*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F166*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F167*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F168*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F169*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F170*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F171*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F172*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F173*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F174*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F175*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F176*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F177*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F178*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F179*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F180*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F181*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F182*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F183*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F184*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F185*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F186*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F187*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F188*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F189*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F190*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F191*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F192*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F193*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F194*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F195*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F196*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F197*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F198*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F199*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F200*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F201*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F202*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F203*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F204*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"",{"$f":"IFERROR(E205/SUM($E$12:$E$511),\"\")","v":""},null,null,null,null,0,null,null,null,null,null,{"$f":"IFERROR(H205*E205,\"\")","v":""},{"$f":"IFERROR(I205*E205,\"\")","v":""},{"$f":"IFERROR(C205-K205,\"\")","v":0},{"$f":"IFERROR(S205/C205,\"\")","v":""},{"$f":"IFERROR(V205*C205,\"\")","v":""},{"$f":"IFERROR(F205*PE!$F$20,\"\")","v":""},{"$f":"IFERROR(J205*D205,\"\")","v":0},{"$f":"IFERROR(G205*D205,\"\")","v":0}]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F206*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F207*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F208*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F209*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F210*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F211*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F212*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F213*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F214*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F215*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F216*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F217*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F218*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F219*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F220*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F221*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F222*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,{"$f":"IFERROR(IF(B223=\"\",\"\",C223*D223),\"\")","v":""},"",null,null,null,null,{"$f":"G223+C223*(H223+I223)+J223","v":0},null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F223*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F224*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F225*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F226*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F227*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F228*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F229*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F230*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F231*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F232*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F233*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F234*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F235*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F236*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F237*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F238*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F239*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F240*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F241*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F242*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F243*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F244*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F245*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F246*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F247*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F248*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F249*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F250*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F251*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F252*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F253*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F254*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F255*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F256*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F257*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F258*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F259*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F260*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F261*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F262*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F263*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F264*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F265*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F266*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F267*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F268*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"",{"$f":"IFERROR(E269/SUM($E$12:$E$511),\"\")","v":""},null,null,null,null,0,null,null,null,null,null,{"$f":"IFERROR(H269*E269,\"\")","v":""},{"$f":"IFERROR(I269*E269,\"\")","v":""},{"$f":"IFERROR(C269-K269,\"\")","v":0},{"$f":"IFERROR(S269/C269,\"\")","v":""},{"$f":"IFERROR(V269*C269,\"\")","v":""},{"$f":"IFERROR(F269*PE!$F$20,\"\")","v":""},{"$f":"IFERROR(J269*D269,\"\")","v":0},{"$f":"IFERROR(G269*D269,\"\")","v":0}]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F270*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F271*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F272*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F273*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F274*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F275*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F276*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F277*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F278*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F279*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F280*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F281*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F282*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F283*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F284*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F285*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F286*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,{"$f":"IFERROR(IF(B287=\"\",\"\",C287*D287),\"\")","v":""},"",null,null,null,null,{"$f":"G287+C287*(H287+I287)+J287","v":0},null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F287*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F288*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F289*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F290*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F291*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F292*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F293*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F294*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F295*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F296*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F297*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F298*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F299*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F300*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F301*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F302*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F303*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F304*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F305*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F306*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F307*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F308*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F309*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F310*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F311*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F312*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F313*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F314*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F315*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F316*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F317*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F318*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F319*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F320*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F321*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F322*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F323*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F324*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F325*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F326*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F327*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F328*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F329*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F330*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F331*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F332*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"",{"$f":"IFERROR(E333/SUM($E$12:$E$511),\"\")","v":""},null,null,null,null,0,null,null,null,null,null,{"$f":"IFERROR(H333*E333,\"\")","v":""},{"$f":"IFERROR(I333*E333,\"\")","v":""},{"$f":"IFERROR(C333-K333,\"\")","v":0},{"$f":"IFERROR(S333/C333,\"\")","v":""},{"$f":"IFERROR(V333*C333,\"\")","v":""},{"$f":"IFERROR(F333*PE!$F$20,\"\")","v":""},{"$f":"IFERROR(J333*D333,\"\")","v":0},{"$f":"IFERROR(G333*D333,\"\")","v":0}]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F334*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F335*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F336*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F337*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F338*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F339*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F340*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F341*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F342*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F343*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F344*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F345*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F346*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F347*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F348*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F349*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F350*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,{"$f":"IFERROR(IF(B351=\"\",\"\",C351*D351),\"\")","v":""},"",null,null,null,null,{"$f":"G351+C351*(H351+I351)+J351","v":0},null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F351*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F352*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F353*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F354*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F355*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F356*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F357*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F358*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F359*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F360*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F361*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F362*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F363*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F364*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F365*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F366*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F367*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F368*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F369*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F370*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F371*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F372*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F373*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F374*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F375*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F376*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F377*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F378*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F379*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F380*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F381*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F382*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F383*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F384*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F385*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F386*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F387*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F388*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F389*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F390*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F391*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F392*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F393*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F394*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F395*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F396*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"",{"$f":"IFERROR(E397/SUM($E$12:$E$511),\"\")","v":""},null,null,null,null,0,null,null,null,null,null,{"$f":"IFERROR(H397*E397,\"\")","v":""},{"$f":"IFERROR(I397*E397,\"\")","v":""},{"$f":"IFERROR(C397-K397,\"\")","v":0},{"$f":"IFERROR(S397/C397,\"\")","v":""},{"$f":"IFERROR(V397*C397,\"\")","v":""},{"$f":"IFERROR(F397*PE!$F$20,\"\")","v":""},{"$f":"IFERROR(J397*D397,\"\")","v":0},{"$f":"IFERROR(G397*D397,\"\")","v":0}]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F398*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F399*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F400*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F401*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F402*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F403*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F404*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F405*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F406*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F407*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F408*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F409*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F410*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F411*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F412*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F413*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F414*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,{"$f":"IFERROR(IF(B415=\"\",\"\",C415*D415),\"\")","v":""},"",null,null,null,null,{"$f":"G415+C415*(H415+I415)+J415","v":0},null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F415*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F416*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F417*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F418*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F419*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F420*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F421*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F422*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F423*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F424*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F425*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F426*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F427*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F428*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F429*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F430*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F431*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F432*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F433*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F434*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F435*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F436*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F437*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F438*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F439*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F440*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F441*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F442*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F443*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F444*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F445*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F446*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F447*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F448*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F449*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F450*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F451*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F452*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F453*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F454*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F455*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F456*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F457*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F458*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F459*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F460*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"",{"$f":"IFERROR(E461/SUM($E$12:$E$511),\"\")","v":""},null,null,null,null,0,null,null,null,null,null,{"$f":"IFERROR(H461*E461,\"\")","v":""},{"$f":"IFERROR(I461*E461,\"\")","v":""},{"$f":"IFERROR(C461-K461,\"\")","v":0},{"$f":"IFERROR(S461/C461,\"\")","v":""},{"$f":"IFERROR(V461*C461,\"\")","v":""},{"$f":"IFERROR(F461*PE!$F$20,\"\")","v":""},{"$f":"IFERROR(J461*D461,\"\")","v":0},{"$f":"IFERROR(G461*D461,\"\")","v":0}]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F462*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F463*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F464*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F465*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F466*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F467*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F468*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F469*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F470*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F471*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F472*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F473*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F474*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F475*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F476*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F477*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F478*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,{"$f":"IFERROR(IF(B479=\"\",\"\",C479*D479),\"\")","v":""},"",null,null,null,null,{"$f":"G479+C479*(H479+I479)+J479","v":0},null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F479*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F480*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F481*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F482*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F483*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F484*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F485*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F486*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F487*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F488*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F489*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F490*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F491*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F492*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F493*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F494*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F495*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F496*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F497*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F498*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F499*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F500*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F501*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F502*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F503*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F504*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F505*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F506*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F507*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F508*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F509*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F510*PE!$F$20,\"\")","v":""},0,0]
[null,null,null,null,"","",null,null,null,null,0,null,null,null,null,null,"","",0,"","",{"$f":"IFERROR(F511*PE!$F$20,\"\")","v":""},0,0]

{"sheet":"PE","index":2,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[17,1,19,1],[20,1,22,1],[17,2,19,2],[20,2,22,2],[11,4,14,4],[15,4,18,4],[19,4,22,4],[11,1,13,1],[11,2,13,2],[14,1,16,1],[14,2,16,2],[19,5,22,5],[11,7,12,7],[13,7,14,7],[15,7,16,7],[17,7,18,7],[19,7,20,7],[11,5,14,5],[15,5,18,5],[11,8,12,8],[13,8,14,8],[15,8,16,8],[17,8,18,8],[19,8,20,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Descrição","Valor (R$)",null,"Descrição","Valor (R$)",null,"Selecione o seu produto:","Calça"]
[null,"Preço de venda médio dos seus produtos",{"$f":"IFERROR(AVERAGEIF(Cad!C12:C511,\">0\"),\"\")","v":85},null,"Qual o valor total dos seus custos fixos?",{"$f":"SUM(Cad!N12:N51)","v":16030},null,{"$f":"\"Receita do(a) \"&I11&\" no Ponto de Equilíbrio\"","v":"Receita do(a) Calça no Ponto de Equilíbrio"},{"$f":"IFERROR(VLOOKUP(I11,Cad!$B$12:$X$511,20,0),\"\")","v":9067.1249355559376}]
[]
[null,null,null,null,null,null,null,"Unidades",{"$f":"IFERROR(VLOOKUP(I11,Cad!$B$12:$X$511,21,0),\"\")","v":75.559374462966147}]
[null,"Margem de contribuição média dos seus produtos",{"$f":"IFERROR(AVERAGEIF(Cad!K12:K511,\">0\"),\"\")","v":40.25}]
[null,null,null,null,"Qual deve ser o faturamento para não ter prejuízo?",{"$f":"IFERROR(F12/(C15/C12),\"\")","v":33852.17391304348},null,"Total de despesas diretas",{"$f":"IFERROR(VLOOKUP(I11,Cad!$B$12:$X$511,10,0)*I14,\"\")","v":4835.7999656298334}]
[]
[null,"Custos diretos totais",{"$f":"SUM(Cad!K12:K511)","v":161},null,null,null,null,"MC unitária",{"$f":"IFERROR(VLOOKUP(I11,Cad!$B$12:$X$511,18,0),\"\")","v":56}]
[]
[null,null,null,null,"Quantos produtos você precisa vender para não ter prejuízo?",{"$f":"IFERROR(F16/C12,\"\")","v":398.26086956521743},null,"MC ponderada",{"$f":"IFERROR(VLOOKUP(I11,Cad!$B$12:$X$511,5,0)*I18,\"\")","v":10.624505928853754}]
[null,"Custos diretos médio por produto",{"$f":"IFERROR(AVERAGEIF(Cad!K12:K511,\">0\"),\"\")","v":40.25}]

{"sheet":"AC","index":3,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Empresa","Diferencial","Produto","Preço Concorrente","Seu Preço","Diferença","Orientação"]
[null,"Camisaria XYZ Ltda","Preço","Camisa",110,{"$f":"IFERROR(IF(D11=\"\",\"\",VLOOKUP(D11,Cad!$B$12:$C$511,2,0)),\"\")","v":100},{"$f":"IF(F11=\"\",\"\",F11-E11)","v":-10},{"$f":"IFERROR(IF(G11<0,\"Seu preço está  \"&-I11*100&\" % mais barato. Vale aumentar?\",IF(G11>0,\"Seu preço está \"&I11*100&\"% mais caro. Diminuir preço?\",\"Seu preço está igual ao de mercado. Manter o preço?\")),\"\")","v":"Seu preço está  9 % mais barato. Vale aumentar?"},{"$f":"IFERROR(ROUND(F11/E11-1,2),\"\")","v":-0.09}]
[null,"Malharia XYZ Ltda","Qualidade","Malha",110,{"$f":"IFERROR(IF(D12=\"\",\"\",VLOOKUP(D12,Cad!$B$12:$C$511,2,0)),\"\")","v":""},{"$f":"IF(F12=\"\",\"\",F12-E12)","v":""},{"$f":"IFERROR(IF(G12<0,\"Seu preço está  \"&-I12*100&\" % mais barato. Vale aumentar?\",IF(G12>0,\"Seu preço está \"&I12*100&\"% mais caro. Diminuir preço?\",\"Seu preço está igual ao de mercado. Manter o preço?\")),\"\")","v":""},{"$f":"IFERROR(ROUND(F12/E12-1,2),\"\")","v":""}]
[null,"Empresa de roupas Ltda","Localização Geográfica","Calça",150,{"$f":"IFERROR(IF(D13=\"\",\"\",VLOOKUP(D13,Cad!$B$12:$C$511,2,0)),\"\")","v":120},-30,"Seu preço está  20 % mais barato. Vale aumentar?",-0.2]
[null,"Roupas femininas Ltda","Preço","Saia",98,{"$f":"IFERROR(IF(D14=\"\",\"\",VLOOKUP(D14,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,"Moda Jeans Ltda","Localização Geográfica","Jeans",140,{"$f":"IFERROR(IF(D15=\"\",\"\",VLOOKUP(D15,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,"Camisaria Colombo","Preço","Cueca",16,{"$f":"IFERROR(IF(D16=\"\",\"\",VLOOKUP(D16,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D17=\"\",\"\",VLOOKUP(D17,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",{"$f":"IFERROR(ROUND(F17/E17-1,2),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(IF(D18=\"\",\"\",VLOOKUP(D18,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",{"$f":"IFERROR(ROUND(F18/E18-1,2),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(IF(D19=\"\",\"\",VLOOKUP(D19,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D20=\"\",\"\",VLOOKUP(D20,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D21=\"\",\"\",VLOOKUP(D21,Cad!$B$12:$C$511,2,0)),\"\")","v":""},{"$f":"IF(F21=\"\",\"\",F21-E21)","v":""},"",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D22=\"\",\"\",VLOOKUP(D22,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D23=\"\",\"\",VLOOKUP(D23,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D24=\"\",\"\",VLOOKUP(D24,Cad!$B$12:$C$511,2,0)),\"\")","v":""},{"$f":"IF(F24=\"\",\"\",F24-E24)","v":""},"",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D25=\"\",\"\",VLOOKUP(D25,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D26=\"\",\"\",VLOOKUP(D26,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D27=\"\",\"\",VLOOKUP(D27,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D28=\"\",\"\",VLOOKUP(D28,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D29=\"\",\"\",VLOOKUP(D29,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D30=\"\",\"\",VLOOKUP(D30,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D31=\"\",\"\",VLOOKUP(D31,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D32=\"\",\"\",VLOOKUP(D32,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D33=\"\",\"\",VLOOKUP(D33,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D34=\"\",\"\",VLOOKUP(D34,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D35=\"\",\"\",VLOOKUP(D35,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D36=\"\",\"\",VLOOKUP(D36,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D37=\"\",\"\",VLOOKUP(D37,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D38=\"\",\"\",VLOOKUP(D38,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D39=\"\",\"\",VLOOKUP(D39,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D40=\"\",\"\",VLOOKUP(D40,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D41=\"\",\"\",VLOOKUP(D41,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D42=\"\",\"\",VLOOKUP(D42,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D43=\"\",\"\",VLOOKUP(D43,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D44=\"\",\"\",VLOOKUP(D44,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D45=\"\",\"\",VLOOKUP(D45,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D46=\"\",\"\",VLOOKUP(D46,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D47=\"\",\"\",VLOOKUP(D47,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D48=\"\",\"\",VLOOKUP(D48,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D49=\"\",\"\",VLOOKUP(D49,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D50=\"\",\"\",VLOOKUP(D50,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D51=\"\",\"\",VLOOKUP(D51,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","",""]
[null,null,null,null,null,{"$f":"IFERROR(IF(D52=\"\",\"\",VLOOKUP(D52,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","Seu preço está 0% mais caro. Diminuir preço?"]
[null,null,null,null,null,{"$f":"IFERROR(IF(D53=\"\",\"\",VLOOKUP(D53,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","Seu preço está 0% mais caro. Diminuir preço?"]
[null,null,null,null,null,{"$f":"IFERROR(IF(D54=\"\",\"\",VLOOKUP(D54,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","Seu preço está 0% mais caro. Diminuir preço?"]
[null,null,null,null,null,{"$f":"IFERROR(IF(D55=\"\",\"\",VLOOKUP(D55,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","Seu preço está 0% mais caro. Diminuir preço?"]
[null,null,null,null,null,{"$f":"IFERROR(IF(D56=\"\",\"\",VLOOKUP(D56,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","Seu preço está 0% mais caro. Diminuir preço?"]
[null,null,null,null,null,{"$f":"IFERROR(IF(D57=\"\",\"\",VLOOKUP(D57,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","Seu preço está 0% mais caro. Diminuir preço?"]
[null,null,null,null,null,{"$f":"IFERROR(IF(D58=\"\",\"\",VLOOKUP(D58,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","Seu preço está 0% mais caro. Diminuir preço?"]
[null,null,null,null,null,{"$f":"IFERROR(IF(D59=\"\",\"\",VLOOKUP(D59,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","Seu preço está 0% mais caro. Diminuir preço?"]
[null,null,null,null,null,{"$f":"IFERROR(IF(D60=\"\",\"\",VLOOKUP(D60,Cad!$B$12:$C$511,2,0)),\"\")","v":""},"","Seu preço está 0% mais caro. Diminuir preço?"]

{"sheet":"RC","index":4,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,1,34,2],[35,1,35,2],[36,1,36,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[27,1,27,2],[15,6,15,7],[15,8,15,9],[17,1,17,7],[18,5,18,7],[19,5,19,7],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,5,23,7],[25,1,25,4],[26,1,26,2],[12,6,12,7],[12,8,12,9],[13,6,13,7],[13,8,13,9],[14,6,14,7],[14,8,14,9],[12,3,12,4],[13,1,13,2],[13,3,13,4],[14,1,14,2],[14,3,14,4],[12,1,12,2],[9,6,9,9],[10,6,10,7],[10,8,10,9],[11,6,11,7],[11,8,11,9],[9,1,9,4],[10,1,10,2],[10,3,10,4],[11,1,11,2],[11,3,11,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Resumo dos Custos Diretos",null,null,null,null,"Top 5 Custos Fixos"]
[null,"Matéria - prima",null,{"$f":"IFERROR(SUM(Cad!G12:G511),\"\")","v":71},null,null,{"$f":"IFERROR(IF(I11=I10,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(I10,Cad!$N$12:$N$51,0),0),MATCH(I11,OFFSET(Cad!$N$12:$N$51,MATCH(I11,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(I11,Cad!$N$12:$N$51,0),1)),\"\"\n)","v":"Pró Labore e salários"},null,{"$f":"IFERROR(LARGE(Cad!N12:N51,1),\"\")","v":6500}]
[null,"Impostos",null,{"$f":"IFERROR(SUM(Cad!I12:I511),\"\")","v":0.48},null,null,{"$f":"IFERROR(IF(I12=I11,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(I11,Cad!$N$12:$N$51,0),0),MATCH(I12,OFFSET(Cad!$N$12:$N$51,MATCH(I12,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(I12,Cad!$N$12:$N$51,0),1)),\"\"\n)","v":"Aluguel"},null,{"$f":"IFERROR(LARGE(Cad!N12:N51,2),\"\")","v":2000}]
[null,"Comissões",null,{"$f":"IFERROR(SUM(Cad!H12:H511),\"\")","v":0.12},null,null,{"$f":"IFERROR(IF(I13=I12,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(I12,Cad!$N$12:$N$51,0),0),MATCH(I13,OFFSET(Cad!$N$12:$N$51,MATCH(I13,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(I13,Cad!$N$12:$N$51,0),1)),\"\"\n)","v":"Marketing"},null,{"$f":"IFERROR(LARGE(Cad!N12:N51,3),\"\")","v":2000}]
[null,"Outros gastos",null,{"$f":"IFERROR(SUM(Cad!J12:J511),\"\")","v":39},null,null,{"$f":"IFERROR(IF(I14=I13,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(I13,Cad!$N$12:$N$51,0),0),MATCH(I14,OFFSET(Cad!$N$12:$N$51,MATCH(I14,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(I14,Cad!$N$12:$N$51,0),1)),\"\"\n)","v":"Outros Custos"},null,{"$f":"IFERROR(LARGE(Cad!N12:N51,4),\"\")","v":1900}]
[null,"Total dos gastos",null,{"$f":"SUM(D11:E14)","v":110.60000000000001},null,null,{"$f":"IFERROR(IF(I15=I14,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(I14,Cad!$N$12:$N$51,0),0),MATCH(I15,OFFSET(Cad!$N$12:$N$51,MATCH(I15,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(I15,Cad!$N$12:$N$51,0),1)),\"\"\n)","v":"Empréstimos"},null,{"$f":"IFERROR(LARGE(Cad!N12:N51,5),\"\")","v":1350}]
[null,null,null,null,null,null,"Total dos custos fixos",null,{"$f":"SUM(Cad!N12:N51)","v":16030}]
[]
[null,"Análise da concorrência (máximo de 5 produtos comparados)"]
[null,"Produtos","Preço médio de mercado","Preço praticado por você","Diferença","Comentário"]
[null,{"$f":"IFERROR(IF(D20=\"\",\"\",IF(D20=D19,INDEX(OFFSET(AC!$D$11:$D$50,MATCH(D20,AC!$F$11:$F$50,0),0),MATCH(D20,OFFSET(AC!$F$11:$F$50,MATCH(D20,AC!$F$11:$F$50,0),0),0),1),INDEX(AC!$D$11:$D$50,MATCH(D20,AC!$F$11:$F$50,0),1))),\"\")","v":"Calça"},{"$f":"IFERROR(VLOOKUP(B20,AC!$D$11:$E$50,2,0),\"\")","v":150},{"$f":"IFERROR(LARGE(AC!$F$11:$F$50,1),\"\")","v":120},{"$f":"IF(ISERROR(\nIF(B20=\"\",\"\",D20-C20)),\"\",IF(B20=\"\",\"\",D20-C20))","v":-30},{"$f":"IF(ISERROR(\nIF(E20<0,\"Seu preço está  \"&-I20*100&\" % mais barato. Vale aumentar?\",IF(E20>0,\"Seu preço está \"&I20*100&\"% mais caro. Diminuir preço?\",\"Seu preço está igual ao de mercado. Manter o preço?\"))),\"\",IF(E20<0,\"Seu preço está  \"&-I20*100&\" % mais barato. Vale aumentar?\",IF(E20>0,\"Seu preço está \"&I20*100&\"% mais caro. Diminuir preço?\",\"Seu preço está igual ao de mercado. Manter o preço?\")))","v":"Seu preço está  20 % mais barato. Vale aumentar?"},null,null,{"$f":"IFERROR(ROUND(D20/C20-1,2),\"\")","v":-0.2}]
[null,{"$f":"IFERROR(IF(D21=\"\",\"\",IF(D21=D20,INDEX(OFFSET(AC!$D$11:$D$50,MATCH(D21,AC!$F$11:$F$50,0),0),MATCH(D21,OFFSET(AC!$F$11:$F$50,MATCH(D21,AC!$F$11:$F$50,0),0),0),1),INDEX(AC!$D$11:$D$50,MATCH(D21,AC!$F$11:$F$50,0),1))),\"\")","v":"Camisa"},{"$f":"IFERROR(VLOOKUP(B21,AC!$D$11:$E$50,2,0),\"\")","v":110},{"$f":"IFERROR(LARGE(AC!$F$11:$F$50,2),\"\")","v":100},{"$f":"IF(ISERROR(\nIF(B21=\"\",\"\",D21-C21)),\"\",IF(B21=\"\",\"\",D21-C21))","v":-10},{"$f":"IF(ISERROR(\nIF(E21<0,\"Seu preço está  \"&-I21*100&\" % mais barato. Vale aumentar?\",IF(E21>0,\"Seu preço está \"&I21*100&\"% mais caro. Diminuir preço?\",\"Seu preço está igual ao de mercado. Manter o preço?\"))),\"\",IF(E21<0,\"Seu preço está  \"&-I21*100&\" % mais barato. Vale aumentar?\",IF(E21>0,\"Seu preço está \"&I21*100&\"% mais caro. Diminuir preço?\",\"Seu preço está igual ao de mercado. Manter o preço?\")))","v":"Seu preço está  9 % mais barato. Vale aumentar?"},null,null,{"$f":"IFERROR(ROUND(D21/C21-1,2),\"\")","v":-0.09}]
[null,{"$f":"IFERROR(IF(D22=\"\",\"\",IF(D22=D21,INDEX(OFFSET(AC!$D$11:$D$50,MATCH(D22,AC!$F$11:$F$50,0),0),MATCH(D22,OFFSET(AC!$F$11:$F$50,MATCH(D22,AC!$F$11:$F$50,0),0),0),1),INDEX(AC!$D$11:$D$50,MATCH(D22,AC!$F$11:$F$50,0),1))),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B22,AC!$D$11:$E$50,2,0),\"\")","v":""},{"$f":"IFERROR(LARGE(AC!$F$11:$F$50,3),\"\")","v":""},{"$f":"IF(ISERROR(\nIF(B22=\"\",\"\",D22-C22)),\"\",IF(B22=\"\",\"\",D22-C22))","v":""},"",null,null,""]
[null,{"$f":"IFERROR(IF(D23=\"\",\"\",IF(D23=D22,INDEX(OFFSET(AC!$D$11:$D$50,MATCH(D23,AC!$F$11:$F$50,0),0),MATCH(D23,OFFSET(AC!$F$11:$F$50,MATCH(D23,AC!$F$11:$F$50,0),0),0),1),INDEX(AC!$D$11:$D$50,MATCH(D23,AC!$F$11:$F$50,0),1))),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B23,AC!$D$11:$E$50,2,0),\"\")","v":""},{"$f":"IFERROR(LARGE(AC!$F$11:$F$50,4),\"\")","v":""},{"$f":"IF(ISERROR(\nIF(B23=\"\",\"\",D23-C23)),\"\",IF(B23=\"\",\"\",D23-C23))","v":""},"",null,null,""]
[null,{"$f":"IFERROR(IF(D24=\"\",\"\",IF(D24=D23,INDEX(OFFSET(AC!$D$11:$D$50,MATCH(D24,AC!$F$11:$F$50,0),0),MATCH(D24,OFFSET(AC!$F$11:$F$50,MATCH(D24,AC!$F$11:$F$50,0),0),0),1),INDEX(AC!$D$11:$D$50,MATCH(D24,AC!$F$11:$F$50,0),1))),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B24,AC!$D$11:$E$50,2,0),\"\")","v":""},{"$f":"IFERROR(LARGE(AC!$F$11:$F$50,5),\"\")","v":""},{"$f":"IF(ISERROR(\nIF(B24=\"\",\"\",D24-C24)),\"\",IF(B24=\"\",\"\",D24-C24))","v":""},"",null,null,""]
[]
[null,"Top 10 Mix de Produtos - Receita Gerada"]
[null,"Produtos",null,"Quantidade a ser vendida","Receita gerada"]
[null,{"$f":"IFERROR(IF(E28=\"\",\"\",IF(E28=E27,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(E28,Cad!$U$12:$U$511,0),0),MATCH(E28,OFFSET(Cad!$U$12:$U$511,MATCH(E28,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(E28,Cad!$U$12:$U$511,0),1))),\"\")","v":"Camiseta"},null,{"$f":"IFERROR(IF(E28=\"\",\"\",IF(E28=E27,INDEX(OFFSET(Cad!$V$12:$V$511,MATCH(E28,Cad!$U$12:$U$511,0),0),MATCH(E28,OFFSET(Cad!$U$12:$U$511,MATCH(E28,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$V$12:$V$511,MATCH(E28,Cad!$U$12:$U$511,0),1))),\"\")","v":220.38150885031797},{"$f":"IFERROR(IF(LARGE(Cad!$U$12:$U$511,F28)=0,\"\",LARGE(Cad!$U$12:$U$511,F28)),\"\")","v":15426.705619522258},1]
[null,{"$f":"IFERROR(IF(E29=\"\",\"\",IF(E29=E28,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(E29,Cad!$U$12:$U$511,0),0),MATCH(E29,OFFSET(Cad!$U$12:$U$511,MATCH(E29,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(E29,Cad!$U$12:$U$511,0),1))),\"\")","v":"Calça"},null,{"$f":"IFERROR(IF(E29=\"\",\"\",IF(E29=E28,INDEX(OFFSET(Cad!$V$12:$V$511,MATCH(E29,Cad!$U$12:$U$511,0),0),MATCH(E29,OFFSET(Cad!$U$12:$U$511,MATCH(E29,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$V$12:$V$511,MATCH(E29,Cad!$U$12:$U$511,0),1))),\"\")","v":75.559374462966147},{"$f":"IFERROR(IF(LARGE(Cad!$U$12:$U$511,F29)=0,\"\",LARGE(Cad!$U$12:$U$511,F29)),\"\")","v":9067.1249355559376},2]
[null,{"$f":"IFERROR(IF(E30=\"\",\"\",IF(E30=E29,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(E30,Cad!$U$12:$U$511,0),0),MATCH(E30,OFFSET(Cad!$U$12:$U$511,MATCH(E30,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(E30,Cad!$U$12:$U$511,0),1))),\"\")","v":"Camisa"},null,{"$f":"IFERROR(IF(E30=\"\",\"\",IF(E30=E29,INDEX(OFFSET(Cad!$V$12:$V$511,MATCH(E30,Cad!$U$12:$U$511,0),0),MATCH(E30,OFFSET(Cad!$U$12:$U$511,MATCH(E30,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$V$12:$V$511,MATCH(E30,Cad!$U$12:$U$511,0),1))),\"\")","v":78.707681732256404},{"$f":"IFERROR(IF(LARGE(Cad!$U$12:$U$511,F30)=0,\"\",LARGE(Cad!$U$12:$U$511,F30)),\"\")","v":7870.7681732256406},3]
[null,{"$f":"IFERROR(IF(E31=\"\",\"\",IF(E31=E30,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(E31,Cad!$U$12:$U$511,0),0),MATCH(E31,OFFSET(Cad!$U$12:$U$511,MATCH(E31,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(E31,Cad!$U$12:$U$511,0),1))),\"\")","v":"Pijamas"},null,{"$f":"IFERROR(IF(E31=\"\",\"\",IF(E31=E30,INDEX(OFFSET(Cad!$V$12:$V$511,MATCH(E31,Cad!$U$12:$U$511,0),0),MATCH(E31,OFFSET(Cad!$U$12:$U$511,MATCH(E31,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$V$12:$V$511,MATCH(E31,Cad!$U$12:$U$511,0),1))),\"\")","v":23.612304519676922},{"$f":"IFERROR(IF(LARGE(Cad!$U$12:$U$511,F31)=0,\"\",LARGE(Cad!$U$12:$U$511,F31)),\"\")","v":1180.6152259838461},4]
[null,{"$f":"IFERROR(IF(E32=\"\",\"\",IF(E32=E31,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(E32,Cad!$U$12:$U$511,0),0),MATCH(E32,OFFSET(Cad!$U$12:$U$511,MATCH(E32,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(E32,Cad!$U$12:$U$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(E32=\"\",\"\",IF(E32=E31,INDEX(OFFSET(Cad!$V$12:$V$511,MATCH(E32,Cad!$U$12:$U$511,0),0),MATCH(E32,OFFSET(Cad!$U$12:$U$511,MATCH(E32,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$V$12:$V$511,MATCH(E32,Cad!$U$12:$U$511,0),1))),\"\")","v":""},{"$f":"IFERROR(IF(LARGE(Cad!$U$12:$U$511,F32)=0,\"\",LARGE(Cad!$U$12:$U$511,F32)),\"\")","v":""},5]
[null,{"$f":"IFERROR(IF(E33=\"\",\"\",IF(E33=E32,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(E33,Cad!$U$12:$U$511,0),0),MATCH(E33,OFFSET(Cad!$U$12:$U$511,MATCH(E33,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(E33,Cad!$U$12:$U$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(E33=\"\",\"\",IF(E33=E32,INDEX(OFFSET(Cad!$V$12:$V$511,MATCH(E33,Cad!$U$12:$U$511,0),0),MATCH(E33,OFFSET(Cad!$U$12:$U$511,MATCH(E33,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$V$12:$V$511,MATCH(E33,Cad!$U$12:$U$511,0),1))),\"\")","v":""},{"$f":"IFERROR(IF(LARGE(Cad!$U$12:$U$511,F33)=0,\"\",LARGE(Cad!$U$12:$U$511,F33)),\"\")","v":""},6]
[null,{"$f":"IFERROR(IF(E34=\"\",\"\",IF(E34=E33,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(E34,Cad!$U$12:$U$511,0),0),MATCH(E34,OFFSET(Cad!$U$12:$U$511,MATCH(E34,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(E34,Cad!$U$12:$U$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(E34=\"\",\"\",IF(E34=E33,INDEX(OFFSET(Cad!$V$12:$V$511,MATCH(E34,Cad!$U$12:$U$511,0),0),MATCH(E34,OFFSET(Cad!$U$12:$U$511,MATCH(E34,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$V$12:$V$511,MATCH(E34,Cad!$U$12:$U$511,0),1))),\"\")","v":""},{"$f":"IFERROR(IF(LARGE(Cad!$U$12:$U$511,F34)=0,\"\",LARGE(Cad!$U$12:$U$511,F34)),\"\")","v":""},7]
[null,{"$f":"IFERROR(IF(E35=\"\",\"\",IF(E35=E34,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(E35,Cad!$U$12:$U$511,0),0),MATCH(E35,OFFSET(Cad!$U$12:$U$511,MATCH(E35,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(E35,Cad!$U$12:$U$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(E35=\"\",\"\",IF(E35=E34,INDEX(OFFSET(Cad!$V$12:$V$511,MATCH(E35,Cad!$U$12:$U$511,0),0),MATCH(E35,OFFSET(Cad!$U$12:$U$511,MATCH(E35,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$V$12:$V$511,MATCH(E35,Cad!$U$12:$U$511,0),1))),\"\")","v":""},{"$f":"IFERROR(IF(LARGE(Cad!$U$12:$U$511,F35)=0,\"\",LARGE(Cad!$U$12:$U$511,F35)),\"\")","v":""},8]
[null,{"$f":"IFERROR(IF(E36=\"\",\"\",IF(E36=E35,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(E36,Cad!$U$12:$U$511,0),0),MATCH(E36,OFFSET(Cad!$U$12:$U$511,MATCH(E36,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(E36,Cad!$U$12:$U$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(E36=\"\",\"\",IF(E36=E35,INDEX(OFFSET(Cad!$V$12:$V$511,MATCH(E36,Cad!$U$12:$U$511,0),0),MATCH(E36,OFFSET(Cad!$U$12:$U$511,MATCH(E36,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$V$12:$V$511,MATCH(E36,Cad!$U$12:$U$511,0),1))),\"\")","v":""},{"$f":"IFERROR(IF(LARGE(Cad!$U$12:$U$511,F36)=0,\"\",LARGE(Cad!$U$12:$U$511,F36)),\"\")","v":""},9]
[null,{"$f":"IFERROR(IF(E37=\"\",\"\",IF(E37=E36,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(E37,Cad!$U$12:$U$511,0),0),MATCH(E37,OFFSET(Cad!$U$12:$U$511,MATCH(E37,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(E37,Cad!$U$12:$U$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(E37=\"\",\"\",IF(E37=E36,INDEX(OFFSET(Cad!$V$12:$V$511,MATCH(E37,Cad!$U$12:$U$511,0),0),MATCH(E37,OFFSET(Cad!$U$12:$U$511,MATCH(E37,Cad!$U$12:$U$511,0),0),0),1),INDEX(Cad!$V$12:$V$511,MATCH(E37,Cad!$U$12:$U$511,0),1))),\"\")","v":""},{"$f":"IFERROR(IF(LARGE(Cad!$U$12:$U$511,F37)=0,\"\",LARGE(Cad!$U$12:$U$511,F37)),\"\")","v":""},10]

{"sheet":"GR","index":5,"n_rows":90,"n_cols":17,"rows_kept":90,"cut":false,"hidden":false,"merged":[[12,6,18,7],[56,6,63,7],[73,6,80,7],[89,6,98,7],[41,6,48,7],[26,6,32,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Top 10 Mix de Produtos - Receita Gerada necessária para \"Ponto de Equilíbrio\""]
[]
[]
[null,null,null,null,null,null,{"$f":"\"O produto que mais gerou receita para atingir o ponto de equilíbrio foi: \"&\"\n\"&'RC'!B28","v":"O produto que mais gerou receita para atingir o ponto de equilíbrio foi: \nCamiseta"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Top 10 Mix de Produtos - Quantidade"]
[]
[]
[null,null,null,null,null,null,{"$f":"\"O produto que tem mais participação no ponto de equilíbrio é \"&GR_Dados!A3&\".\"&\"\n\"&\" A quantidade vendida de \"&GR_Dados!A3&\" é de \"&GR_Dados!E3&\" unidades.\"","v":"O produto que tem mais participação no ponto de equilíbrio é Camiseta.\n A quantidade vendida de Camiseta é de 220 unidades."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Top 10 Margem de Contribuição"]
[]
[]
[null,null,null,null,null,null,{"$f":"\"O produto que tem o maior índice de margem de contribuição é \"&GR_Dados!A16&\".\"&\"\n\"&\" O IMC de \"&GR_Dados!A16&\" é de \"&GR_Dados!C16*100&\" %.\"","v":"O produto que tem o maior índice de margem de contribuição é Camiseta.\n O IMC de Camiseta é de 65 %."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Top 10 Custos Fixos",null,null,null,null,null,null,null,null,null,null,null,"Custos Fixos:","Lucro:","custos maior que lucro","custo menor que lucro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PE!F12","v":16030},{"$f":"SUM(Cad!E12:E511)-'RC'!D15-'RC'!I16","v":9159.4000000000015},"A soma dos seus custos diretos e custos fixos fazem com que eles sejam maiores que seu lucro. Significa que o lucro obtido não paga seus custos com o volume de vendas que foi estipulado.\nDica: Faça uma revisão na operação do seu negócio com o intuito de reduzir todos os seus custos para se tornar mais competitivo sem deixar de obter lucro.","Parabéns! Seu lucro é maior que os seus custos fixos. Mantenha esse processo para não deixar que seus custos ultrapassem o seu lucro."]
[null,null,null,null,null,null,{"$f":"IF(N56>O56,P56,Q56)","v":"A soma dos seus custos diretos e custos fixos fazem com que eles sejam maiores que seu lucro. Significa que o lucro obtido não paga seus custos com o volume de vendas que foi estipulado.\nDica: Faça uma revisão na operação do seu negócio com o intuito de reduzir todos os seus custos para se tornar mais competitivo sem deixar de obter lucro."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Custos Diretos"]
[]
[]
[null,null,null,null,null,null,{"$f":"\"Os custos diretos são aqueles que variam de acordo com o volume de vendas. Sua média de custos diretos é de R$ \"&GR_Dados!C48&\" e o seu custo mais elevado está \"&GR_Dados!D48*100&\"% acima da média.\"&\"\n\n\"&\"Dica: É muito comum esquecer de alguns itens dessa parte de custos diretos. Por isso, faça uma avaliação mais criteriosa para entender quais são os itens que ainda podem estar sendo esquecidos.\"","v":"Os custos diretos são aqueles que variam de acordo com o volume de vendas. Sua média de custos diretos é de R$ 27,65 e o seu custo mais elevado está 157% acima da média.\n\nDica: É muito comum esquecer de alguns itens dessa parte de custos diretos. Por isso, faça uma avaliação mais criteriosa para entender quais são os itens que ainda podem estar sendo esquecidos."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Análise dos Concorrentes"]
[]
[]
[null,null,null,null,null,null,{"$f":"\"Você tem \"&GR_Dados!C52&\" concorrentes analisados e seu preço médio está inferior à média de mercado. Isso pode ser um bom sinal, mas não é algo para se animar muito.\"&\"\n\"&\"Dica:\"&\"\n\"&\"Existem muitas formas de se diferenciar em um negócio. Fatores como qualidade, posicionamento, localização geográfica (e outros fatores) são tão importantes quanto o preço. Faça uma avaliação para saber se o preço é a única diferenciação que você precisa.\"","v":"Você tem 6 concorrentes analisados e seu preço médio está inferior à média de mercado. Isso pode ser um bom sinal, mas não é algo para se animar muito.\nDica:\nExistem muitas formas de se diferenciar em um negócio. Fatores como qualidade, posicionamento, localização geográfica (e outros fatores) são tão importantes quanto o preço. Faça uma avaliação para saber se o preço é a única diferenciação que você precisa."}]

{"sheet":"RI","index":6,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[10,7,10,8],[10,2,10,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Empresa:",{"$f":"Menu!G26","v":"Sebrae"},null,null,null,null,{"$f":"CONCATENATE(\"data da impressão: \",TEXT(TODAY(),\"DD/MM/AAAA\"))","v":"data da impressão: 31/03/2023"}]
[]
[null,"1. Margem de Contribuição"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Resultados Consolidados"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Gráficos"]

{"sheet":"Instruções","index":7,"n_rows":146,"n_cols":2,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. Cadastros Gerais"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Ponto de Equilíbrio"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Análise da Concorrência"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4. Resultados Consolidados"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5. Gráficos"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6. Relatório de Impressão"]

{"sheet":"GR_Dados","index":8,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":false,"merged":[[44,0,44,1],[45,0,45,1],[46,0,46,1],[51,0,51,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[42,0,42,1],[43,0,43,1],[34,0,34,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[19,0,19,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1]]}
["Top 10 Mix de Produtos - quantidade"]
["Produtos",null,"Quantidade a ser vendida"]
[{"$f":"IFERROR(IF(C3=\"\",\"\",IF(C3=C2,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C3,Cad!$V$12:$V$511,0),0),MATCH(C3,OFFSET(Cad!$V$12:$V$511,MATCH(C3,Cad!$V$12:$V$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C3,Cad!$V$12:$V$511,0),1))),\"\")","v":"Camiseta"},null,{"$f":"IFERROR(IF(LARGE(Cad!$V$12:$V$511,D3)=0,\"\",LARGE(Cad!$V$12:$V$511,D3)),\"\")","v":220.38150885031797},1,{"$f":"IF(C3=\"\",\"\",ROUND(C3,0))","v":220}]
[{"$f":"IFERROR(IF(C4=\"\",\"\",IF(C4=C3,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C4,Cad!$V$12:$V$511,0),0),MATCH(C4,OFFSET(Cad!$V$12:$V$511,MATCH(C4,Cad!$V$12:$V$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C4,Cad!$V$12:$V$511,0),1))),\"\")","v":"Camisa"},null,{"$f":"IFERROR(IF(LARGE(Cad!$V$12:$V$511,D4)=0,\"\",LARGE(Cad!$V$12:$V$511,D4)),\"\")","v":78.707681732256404},2,{"$f":"IF(C4=\"\",\"\",ROUND(C4,0))","v":79}]
[{"$f":"IFERROR(IF(C5=\"\",\"\",IF(C5=C4,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C5,Cad!$V$12:$V$511,0),0),MATCH(C5,OFFSET(Cad!$V$12:$V$511,MATCH(C5,Cad!$V$12:$V$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C5,Cad!$V$12:$V$511,0),1))),\"\")","v":"Calça"},null,{"$f":"IFERROR(IF(LARGE(Cad!$V$12:$V$511,D5)=0,\"\",LARGE(Cad!$V$12:$V$511,D5)),\"\")","v":75.559374462966147},3,76]
[{"$f":"IFERROR(IF(C6=\"\",\"\",IF(C6=C5,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C6,Cad!$V$12:$V$511,0),0),MATCH(C6,OFFSET(Cad!$V$12:$V$511,MATCH(C6,Cad!$V$12:$V$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C6,Cad!$V$12:$V$511,0),1))),\"\")","v":"Pijamas"},null,{"$f":"IFERROR(IF(LARGE(Cad!$V$12:$V$511,D6)=0,\"\",LARGE(Cad!$V$12:$V$511,D6)),\"\")","v":23.612304519676922},4,24]
[{"$f":"IFERROR(IF(C7=\"\",\"\",IF(C7=C6,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C7,Cad!$V$12:$V$511,0),0),MATCH(C7,OFFSET(Cad!$V$12:$V$511,MATCH(C7,Cad!$V$12:$V$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C7,Cad!$V$12:$V$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$V$12:$V$511,D7)=0,\"\",LARGE(Cad!$V$12:$V$511,D7)),\"\")","v":""},5,""]
[{"$f":"IFERROR(IF(C8=\"\",\"\",IF(C8=C7,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C8,Cad!$V$12:$V$511,0),0),MATCH(C8,OFFSET(Cad!$V$12:$V$511,MATCH(C8,Cad!$V$12:$V$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C8,Cad!$V$12:$V$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$V$12:$V$511,D8)=0,\"\",LARGE(Cad!$V$12:$V$511,D8)),\"\")","v":""},6,""]
[{"$f":"IFERROR(IF(C9=\"\",\"\",IF(C9=C8,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C9,Cad!$V$12:$V$511,0),0),MATCH(C9,OFFSET(Cad!$V$12:$V$511,MATCH(C9,Cad!$V$12:$V$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C9,Cad!$V$12:$V$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$V$12:$V$511,D9)=0,\"\",LARGE(Cad!$V$12:$V$511,D9)),\"\")","v":""},7,""]
[{"$f":"IFERROR(IF(C10=\"\",\"\",IF(C10=C9,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C10,Cad!$V$12:$V$511,0),0),MATCH(C10,OFFSET(Cad!$V$12:$V$511,MATCH(C10,Cad!$V$12:$V$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C10,Cad!$V$12:$V$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$V$12:$V$511,D10)=0,\"\",LARGE(Cad!$V$12:$V$511,D10)),\"\")","v":""},8,""]
[{"$f":"IFERROR(IF(C11=\"\",\"\",IF(C11=C10,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C11,Cad!$V$12:$V$511,0),0),MATCH(C11,OFFSET(Cad!$V$12:$V$511,MATCH(C11,Cad!$V$12:$V$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C11,Cad!$V$12:$V$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$V$12:$V$511,D11)=0,\"\",LARGE(Cad!$V$12:$V$511,D11)),\"\")","v":""},9,""]
[{"$f":"IFERROR(IF(C12=\"\",\"\",IF(C12=C11,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C12,Cad!$V$12:$V$511,0),0),MATCH(C12,OFFSET(Cad!$V$12:$V$511,MATCH(C12,Cad!$V$12:$V$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C12,Cad!$V$12:$V$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$V$12:$V$511,D12)=0,\"\",LARGE(Cad!$V$12:$V$511,D12)),\"\")","v":""},10,""]
[]
[]
["Produtos",null,"Margem de Contribuição"]
[{"$f":"IFERROR(IF(C16=\"\",\"\",IF(C16=C15,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C16,Cad!$T$12:$T$511,0),0),MATCH(C16,OFFSET(Cad!$T$12:$T$511,MATCH(C16,Cad!$T$12:$T$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C16,Cad!$T$12:$T$511,0),1))),\"\")","v":"Camiseta"},null,{"$f":"IFERROR(IF(LARGE(Cad!$T$12:$T$511,D16)=0,\"\",LARGE(Cad!$T$12:$T$511,D16)),\"\")","v":0.65},1]
[{"$f":"IFERROR(IF(C17=\"\",\"\",IF(C17=C16,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C17,Cad!$T$12:$T$511,0),0),MATCH(C17,OFFSET(Cad!$T$12:$T$511,MATCH(C17,Cad!$T$12:$T$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C17,Cad!$T$12:$T$511,0),1))),\"\")","v":"Camisa"},null,{"$f":"IFERROR(IF(LARGE(Cad!$T$12:$T$511,D17)=0,\"\",LARGE(Cad!$T$12:$T$511,D17)),\"\")","v":0.6},2]
[{"$f":"IFERROR(IF(C18=\"\",\"\",IF(C18=C17,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C18,Cad!$T$12:$T$511,0),0),MATCH(C18,OFFSET(Cad!$T$12:$T$511,MATCH(C18,Cad!$T$12:$T$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C18,Cad!$T$12:$T$511,0),1))),\"\")","v":"Calça"},null,{"$f":"IFERROR(IF(LARGE(Cad!$T$12:$T$511,D18)=0,\"\",LARGE(Cad!$T$12:$T$511,D18)),\"\")","v":0.46666666666666667},3]
[{"$f":"IFERROR(IF(C19=\"\",\"\",IF(C19=C18,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C19,Cad!$T$12:$T$511,0),0),MATCH(C19,OFFSET(Cad!$T$12:$T$511,MATCH(C19,Cad!$T$12:$T$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C19,Cad!$T$12:$T$511,0),1))),\"\")","v":"Pijamas"},null,{"$f":"IFERROR(IF(LARGE(Cad!$T$12:$T$511,D19)=0,\"\",LARGE(Cad!$T$12:$T$511,D19)),\"\")","v":0.35},4]
[{"$f":"IFERROR(IF(C20=\"\",\"\",IF(C20=C19,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C20,Cad!$T$12:$T$511,0),0),MATCH(C20,OFFSET(Cad!$T$12:$T$511,MATCH(C20,Cad!$T$12:$T$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C20,Cad!$T$12:$T$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$T$12:$T$511,D20)=0,\"\",LARGE(Cad!$T$12:$T$511,D20)),\"\")","v":""},5]
[{"$f":"IFERROR(IF(C21=\"\",\"\",IF(C21=C20,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C21,Cad!$T$12:$T$511,0),0),MATCH(C21,OFFSET(Cad!$T$12:$T$511,MATCH(C21,Cad!$T$12:$T$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C21,Cad!$T$12:$T$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$T$12:$T$511,D21)=0,\"\",LARGE(Cad!$T$12:$T$511,D21)),\"\")","v":""},6]
[{"$f":"IFERROR(IF(C22=\"\",\"\",IF(C22=C21,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C22,Cad!$T$12:$T$511,0),0),MATCH(C22,OFFSET(Cad!$T$12:$T$511,MATCH(C22,Cad!$T$12:$T$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C22,Cad!$T$12:$T$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$T$12:$T$511,D22)=0,\"\",LARGE(Cad!$T$12:$T$511,D22)),\"\")","v":""},7]
[{"$f":"IFERROR(IF(C23=\"\",\"\",IF(C23=C22,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C23,Cad!$T$12:$T$511,0),0),MATCH(C23,OFFSET(Cad!$T$12:$T$511,MATCH(C23,Cad!$T$12:$T$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C23,Cad!$T$12:$T$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$T$12:$T$511,D23)=0,\"\",LARGE(Cad!$T$12:$T$511,D23)),\"\")","v":""},8]
[{"$f":"IFERROR(IF(C24=\"\",\"\",IF(C24=C23,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C24,Cad!$T$12:$T$511,0),0),MATCH(C24,OFFSET(Cad!$T$12:$T$511,MATCH(C24,Cad!$T$12:$T$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C24,Cad!$T$12:$T$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$T$12:$T$511,D24)=0,\"\",LARGE(Cad!$T$12:$T$511,D24)),\"\")","v":""},9]
[{"$f":"IFERROR(IF(C25=\"\",\"\",IF(C25=C24,INDEX(OFFSET(Cad!$B$12:$B$511,MATCH(C25,Cad!$T$12:$T$511,0),0),MATCH(C25,OFFSET(Cad!$T$12:$T$511,MATCH(C25,Cad!$T$12:$T$511,0),0),0),1),INDEX(Cad!$B$12:$B$511,MATCH(C25,Cad!$T$12:$T$511,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$T$12:$T$511,D25)=0,\"\",LARGE(Cad!$T$12:$T$511,D25)),\"\")","v":""},10]
[]
[]
[]
["Custos fixos",null,"Valor"]
[{"$f":"IFERROR(IF(C30=\"\",\"\",IF(C30=C29,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(C30,Cad!$N$12:$N$51,0),0),MATCH(C30,OFFSET(Cad!$N$12:$N$51,MATCH(C30,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(C30,Cad!$N$12:$N$51,0),1))),\"\")","v":"Pró Labore e salários"},null,{"$f":"IFERROR(IF(LARGE(Cad!$N$12:$N$51,D30)=0,\"\",LARGE(Cad!$N$12:$N$51,D30)),\"\")","v":6500},1]
[{"$f":"IFERROR(IF(C31=\"\",\"\",IF(C31=C30,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(C31,Cad!$N$12:$N$51,0),0),MATCH(C31,OFFSET(Cad!$N$12:$N$51,MATCH(C31,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(C31,Cad!$N$12:$N$51,0),1))),\"\")","v":"Aluguel"},null,{"$f":"IFERROR(IF(LARGE(Cad!$N$12:$N$51,D31)=0,\"\",LARGE(Cad!$N$12:$N$51,D31)),\"\")","v":2000},2]
[{"$f":"IFERROR(IF(C32=\"\",\"\",IF(C32=C31,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(C32,Cad!$N$12:$N$51,0),0),MATCH(C32,OFFSET(Cad!$N$12:$N$51,MATCH(C32,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(C32,Cad!$N$12:$N$51,0),1))),\"\")","v":"Marketing"},null,{"$f":"IFERROR(IF(LARGE(Cad!$N$12:$N$51,D32)=0,\"\",LARGE(Cad!$N$12:$N$51,D32)),\"\")","v":2000},3]
[{"$f":"IFERROR(IF(C33=\"\",\"\",IF(C33=C32,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(C33,Cad!$N$12:$N$51,0),0),MATCH(C33,OFFSET(Cad!$N$12:$N$51,MATCH(C33,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(C33,Cad!$N$12:$N$51,0),1))),\"\")","v":"Outros Custos"},null,{"$f":"IFERROR(IF(LARGE(Cad!$N$12:$N$51,D33)=0,\"\",LARGE(Cad!$N$12:$N$51,D33)),\"\")","v":1900},4]
[{"$f":"IFERROR(IF(C34=\"\",\"\",IF(C34=C33,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(C34,Cad!$N$12:$N$51,0),0),MATCH(C34,OFFSET(Cad!$N$12:$N$51,MATCH(C34,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(C34,Cad!$N$12:$N$51,0),1))),\"\")","v":"Empréstimos"},null,{"$f":"IFERROR(IF(LARGE(Cad!$N$12:$N$51,D34)=0,\"\",LARGE(Cad!$N$12:$N$51,D34)),\"\")","v":1350},5]
[{"$f":"IFERROR(IF(C35=\"\",\"\",IF(C35=C34,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(C35,Cad!$N$12:$N$51,0),0),MATCH(C35,OFFSET(Cad!$N$12:$N$51,MATCH(C35,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(C35,Cad!$N$12:$N$51,0),1))),\"\")","v":"Legais e Jurídicos"},null,{"$f":"IFERROR(IF(LARGE(Cad!$N$12:$N$51,D35)=0,\"\",LARGE(Cad!$N$12:$N$51,D35)),\"\")","v":980},6]
[{"$f":"IFERROR(IF(C36=\"\",\"\",IF(C36=C35,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(C36,Cad!$N$12:$N$51,0),0),MATCH(C36,OFFSET(Cad!$N$12:$N$51,MATCH(C36,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(C36,Cad!$N$12:$N$51,0),1))),\"\")","v":"Telefone e internet"},null,{"$f":"IFERROR(IF(LARGE(Cad!$N$12:$N$51,D36)=0,\"\",LARGE(Cad!$N$12:$N$51,D36)),\"\")","v":700},7]
[{"$f":"IFERROR(IF(C37=\"\",\"\",IF(C37=C36,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(C37,Cad!$N$12:$N$51,0),0),MATCH(C37,OFFSET(Cad!$N$12:$N$51,MATCH(C37,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(C37,Cad!$N$12:$N$51,0),1))),\"\")","v":"Taxa de propriedade (águal e luz)"},null,{"$f":"IFERROR(IF(LARGE(Cad!$N$12:$N$51,D37)=0,\"\",LARGE(Cad!$N$12:$N$51,D37)),\"\")","v":600},8]
[{"$f":"IFERROR(IF(C38=\"\",\"\",IF(C38=C37,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(C38,Cad!$N$12:$N$51,0),0),MATCH(C38,OFFSET(Cad!$N$12:$N$51,MATCH(C38,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(C38,Cad!$N$12:$N$51,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$N$12:$N$51,D38)=0,\"\",LARGE(Cad!$N$12:$N$51,D38)),\"\")","v":""},9]
[{"$f":"IFERROR(IF(C39=\"\",\"\",IF(C39=C38,INDEX(OFFSET(Cad!$M$12:$M$51,MATCH(C39,Cad!$N$12:$N$51,0),0),MATCH(C39,OFFSET(Cad!$N$12:$N$51,MATCH(C39,Cad!$N$12:$N$51,0),0),0),1),INDEX(Cad!$M$12:$M$51,MATCH(C39,Cad!$N$12:$N$51,0),1))),\"\")","v":""},null,{"$f":"IFERROR(IF(LARGE(Cad!$N$12:$N$51,D39)=0,\"\",LARGE(Cad!$N$12:$N$51,D39)),\"\")","v":""},10]
[]
[]
[]
["Custos diretos",null,"Valor"]
[{"$f":"IFERROR(IF(C44=\"\",\"\",IF(C44=C43,INDEX(OFFSET('RC'!$B$11:$B$14,MATCH(C44,'RC'!$D$11:$D$14,0),0),MATCH(C44,OFFSET('RC'!$D$11:$D$14,MATCH(C44,'RC'!$D$11:$D$14,0),0),0),1),INDEX('RC'!$B$11:$B$14,MATCH(C44,'RC'!$D$11:$D$14,0),1))),\"\")","v":"Matéria - prima"},null,{"$f":"IFERROR(IF(LARGE('RC'!$D$11:$D$14,D30)=0,\"\",LARGE('RC'!$D$11:$D$14,D30)),\"\")","v":71},1]
[{"$f":"IFERROR(IF(C45=\"\",\"\",IF(C45=C44,INDEX(OFFSET('RC'!$B$11:$B$14,MATCH(C45,'RC'!$D$11:$D$14,0),0),MATCH(C45,OFFSET('RC'!$D$11:$D$14,MATCH(C45,'RC'!$D$11:$D$14,0),0),0),1),INDEX('RC'!$B$11:$B$14,MATCH(C45,'RC'!$D$11:$D$14,0),1))),\"\")","v":"Outros gastos"},null,{"$f":"IFERROR(IF(LARGE('RC'!$D$11:$D$14,D31)=0,\"\",LARGE('RC'!$D$11:$D$14,D31)),\"\")","v":39},2]
[{"$f":"IFERROR(IF(C46=\"\",\"\",IF(C46=C45,INDEX(OFFSET('RC'!$B$11:$B$14,MATCH(C46,'RC'!$D$11:$D$14,0),0),MATCH(C46,OFFSET('RC'!$D$11:$D$14,MATCH(C46,'RC'!$D$11:$D$14,0),0),0),1),INDEX('RC'!$B$11:$B$14,MATCH(C46,'RC'!$D$11:$D$14,0),1))),\"\")","v":"Impostos"},null,{"$f":"IFERROR(IF(LARGE('RC'!$D$11:$D$14,D32)=0,\"\",LARGE('RC'!$D$11:$D$14,D32)),\"\")","v":0.48},3]
[{"$f":"IFERROR(IF(C47=\"\",\"\",IF(C47=C46,INDEX(OFFSET('RC'!$B$11:$B$14,MATCH(C47,'RC'!$D$11:$D$14,0),0),MATCH(C47,OFFSET('RC'!$D$11:$D$14,MATCH(C47,'RC'!$D$11:$D$14,0),0),0),1),INDEX('RC'!$B$11:$B$14,MATCH(C47,'RC'!$D$11:$D$14,0),1))),\"\")","v":"Comissões"},null,{"$f":"IFERROR(IF(LARGE('RC'!$D$11:$D$14,D33)=0,\"\",LARGE('RC'!$D$11:$D$14,D33)),\"\")","v":0.12},4]
[null,null,{"$f":"AVERAGE(C44:C47)","v":27.650000000000002},{"$f":"ROUND(C44/C48-1,2)","v":1.57}]
[]
[]
[]
["Qtd de concorrentes",null,{"$f":"COUNTA(AC!$B$11:$B$60)","v":6}]